Quản lý nhân sự công ty bằng c# _ full source code
60.440 lượt xem;
- SchedulerDataset.xsd
- QuanLyNhanSu /
- project /
1 <?xml version="1.0" encoding="utf-8"?>
2 <xs:schema id="SchedulerDataset" targetNamespace="http://tempuri.org/SchedulerDataset.xsd" xmlns:mstns="http://tempuri.org/SchedulerDataset.xsd" xmlns="http://tempuri.org/SchedulerDataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QuanLyNhanSuConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanLyNhanSuConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QuanLyNhanSu.Properties.Settings.GlobalReference.Default.QuanLyNhanSuConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TransientAppointmentsResourcesTableAdapter" GeneratorDataComponentClassName="TransientAppointmentsResourcesTableAdapter" Name="TransientAppointmentsResources" UserDataComponentName="TransientAppointmentsResourcesTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.TransientAppointmentsResources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[TransientAppointmentsResources] ([AppointmentID], [ResourceID]) VALUES (@AppointmentID, @ResourceID)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AppointmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppointmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ResourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
19 </Parameters>
20 </DbCommand>
21 </InsertCommand>
22 <SelectCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>SELECT AppointmentID, ResourceID FROM dbo.TransientAppointmentsResources</CommandText>
25 <Parameters />
26 </DbCommand>
27 </SelectCommand>
28 </DbSource>
29 </MainSource>
30 <Mappings>
31 <Mapping SourceColumn="AppointmentID" DataSetColumn="AppointmentID" />
32 <Mapping SourceColumn="ResourceID" DataSetColumn="ResourceID" />
33 </Mappings>
34 <Sources />
35 </TableAdapter>
36 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResourcesTableAdapter" GeneratorDataComponentClassName="ResourcesTableAdapter" Name="Resources" UserDataComponentName="ResourcesTableAdapter">
37 <MainSource>
38 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.Resources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
39 <DeleteCommand>
40 <DbCommand CommandType="Text" ModifiedByUser="false">
41 <CommandText>DELETE FROM [dbo].[Resources] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)))</CommandText>
42 <Parameters>
43 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
46 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
47 </Parameters>
48 </DbCommand>
49 </DeleteCommand>
50 <InsertCommand>
51 <DbCommand CommandType="Text" ModifiedByUser="false">
52 <CommandText>INSERT INTO [dbo].[Resources] ([ID], [Name], [Image]) VALUES (@ID, @Name, @Image);
53 SELECT ID, Name, Image FROM Resources WHERE (ID = @ID)</CommandText>
54 <Parameters>
55 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
58 </Parameters>
59 </DbCommand>
60 </InsertCommand>
61 <SelectCommand>
62 <DbCommand CommandType="Text" ModifiedByUser="false">
63 <CommandText>SELECT ID, Name, Image FROM dbo.Resources</CommandText>
64 <Parameters />
65 </DbCommand>
66 </SelectCommand>
67 <UpdateCommand>
68 <DbCommand CommandType="Text" ModifiedByUser="false">
69 <CommandText>UPDATE [dbo].[Resources] SET [ID] = @ID, [Name] = @Name, [Image] = @Image WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)));
70 SELECT ID, Name, Image FROM Resources WHERE (ID = @ID)</CommandText>
71 <Parameters>
72 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
73 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
75 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
76 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
77 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
79 </Parameters>
80 </DbCommand>
81 </UpdateCommand>
82 </DbSource>
83 </MainSource>
84 <Mappings>
85 <Mapping SourceColumn="ID" DataSetColumn="ID" />
86 <Mapping SourceColumn="Name" DataSetColumn="Name" />
87 <Mapping SourceColumn="Image" DataSetColumn="Image" />
88 </Mappings>
89 <Sources />
90 </TableAdapter>
91 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AppointmentsTableAdapter" GeneratorDataComponentClassName="AppointmentsTableAdapter" Name="Appointments" UserDataComponentName="AppointmentsTableAdapter">
92 <MainSource>
93 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.Appointments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
94 <DeleteCommand>
95 <DbCommand CommandType="Text" ModifiedByUser="false">
96 <CommandText>DELETE FROM [dbo].[Appointments] WHERE (([ID] = @Original_ID) AND ([Summary] = @Original_Summary) AND ([Start] = @Original_Start) AND ([End] = @Original_End) AND ((@IsNull_RecurrenceRule = 1 AND [RecurrenceRule] IS NULL) OR ([RecurrenceRule] = @Original_RecurrenceRule)) AND ((@IsNull_MasterEventId = 1 AND [MasterEventId] IS NULL) OR ([MasterEventId] = @Original_MasterEventId)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)) AND ([BackgroundId] = @Original_BackgroundId) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)))</CommandText>
97 <Parameters>
98 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Original" />
100 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
101 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
102 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecurrenceRule" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="true" SourceVersion="Original" />
103 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Original" />
104 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="true" SourceVersion="Original" />
105 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Original" />
106 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
107 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
108 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Original" />
109 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
110 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
111 </Parameters>
112 </DbCommand>
113 </DeleteCommand>
114 <InsertCommand>
115 <DbCommand CommandType="Text" ModifiedByUser="false">
116 <CommandText>INSERT INTO [dbo].[Appointments] ([Summary], [Start], [End], [RecurrenceRule], [MasterEventId], [Location], [Description], [BackgroundId], [StatusID]) VALUES (@Summary, @Start, @End, @RecurrenceRule, @MasterEventId, @Location, @Description, @BackgroundId, @StatusID);
117 SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM Appointments WHERE (ID = SCOPE_IDENTITY())</CommandText>
118 <Parameters>
119 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
120 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
121 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Current" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Current" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
125 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
126 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Current" />
127 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
128 </Parameters>
129 </DbCommand>
130 </InsertCommand>
131 <SelectCommand>
132 <DbCommand CommandType="Text" ModifiedByUser="false">
133 <CommandText>SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM dbo.Appointments</CommandText>
134 <Parameters />
135 </DbCommand>
136 </SelectCommand>
137 <UpdateCommand>
138 <DbCommand CommandType="Text" ModifiedByUser="false">
139 <CommandText>UPDATE [dbo].[Appointments] SET [Summary] = @Summary, [Start] = @Start, [End] = @End, [RecurrenceRule] = @RecurrenceRule, [MasterEventId] = @MasterEventId, [Location] = @Location, [Description] = @Description, [BackgroundId] = @BackgroundId, [StatusID] = @StatusID WHERE (([ID] = @Original_ID) AND ([Summary] = @Original_Summary) AND ([Start] = @Original_Start) AND ([End] = @Original_End) AND ((@IsNull_RecurrenceRule = 1 AND [RecurrenceRule] IS NULL) OR ([RecurrenceRule] = @Original_RecurrenceRule)) AND ((@IsNull_MasterEventId = 1 AND [MasterEventId] IS NULL) OR ([MasterEventId] = @Original_MasterEventId)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)) AND ([BackgroundId] = @Original_BackgroundId) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)));
140 SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM Appointments WHERE (ID = @ID)</CommandText>
141 <Parameters>
142 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
143 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
144 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
145 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Current" />
146 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Current" />
147 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
148 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
149 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Current" />
150 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
151 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
152 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Original" />
153 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
154 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
155 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecurrenceRule" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="true" SourceVersion="Original" />
156 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Original" />
157 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="true" SourceVersion="Original" />
158 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Original" />
159 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
160 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
161 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Original" />
162 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
163 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
164 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
165 </Parameters>
166 </DbCommand>
167 </UpdateCommand>
168 </DbSource>
169 </MainSource>
170 <Mappings>
171 <Mapping SourceColumn="ID" DataSetColumn="ID" />
172 <Mapping SourceColumn="Summary" DataSetColumn="Summary" />
173 <Mapping SourceColumn="Start" DataSetColumn="Start" />
174 <Mapping SourceColumn="End" DataSetColumn="End" />
175 <Mapping SourceColumn="RecurrenceRule" DataSetColumn="RecurrenceRule" />
176 <Mapping SourceColumn="MasterEventId" DataSetColumn="MasterEventId" />
177 <Mapping SourceColumn="Location" DataSetColumn="Location" />
178 <Mapping SourceColumn="Description" DataSetColumn="Description" />
179 <Mapping SourceColumn="BackgroundId" DataSetColumn="BackgroundId" />
180 <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
181 </Mappings>
182 <Sources />
183 </TableAdapter>
184 </Tables>
185 <Sources />
186 </DataSource>
187 </xs:appinfo>
188 </xs:annotation>
189 <xs:element name="SchedulerDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="SchedulerDataset" msprop:Generator_UserDSName="SchedulerDataset" msprop:EnableTableAdapterManager="true">
190 <xs:complexType>
191 <xs:choice minOccurs="0" maxOccurs="unbounded">
192 <xs:element name="TransientAppointmentsResources" msprop:Generator_UserTableName="TransientAppointmentsResources" msprop:Generator_RowDeletedName="TransientAppointmentsResourcesRowDeleted" msprop:Generator_TableClassName="TransientAppointmentsResourcesDataTable" msprop:Generator_RowChangedName="TransientAppointmentsResourcesRowChanged" msprop:Generator_RowClassName="TransientAppointmentsResourcesRow" msprop:Generator_RowChangingName="TransientAppointmentsResourcesRowChanging" msprop:Generator_RowEvArgName="TransientAppointmentsResourcesRowChangeEvent" msprop:Generator_RowEvHandlerName="TransientAppointmentsResourcesRowChangeEventHandler" msprop:Generator_TablePropName="TransientAppointmentsResources" msprop:Generator_TableVarName="tableTransientAppointmentsResources" msprop:Generator_RowDeletingName="TransientAppointmentsResourcesRowDeleting">
193 <xs:complexType>
194 <xs:sequence>
195 <xs:element name="AppointmentID" msprop:Generator_UserColumnName="AppointmentID" msprop:Generator_ColumnPropNameInRow="AppointmentID" msprop:Generator_ColumnVarNameInTable="columnAppointmentID" msprop:Generator_ColumnPropNameInTable="AppointmentIDColumn" type="xs:int" minOccurs="0" />
196 <xs:element name="ResourceID" msprop:Generator_UserColumnName="ResourceID" msprop:Generator_ColumnPropNameInRow="ResourceID" msprop:Generator_ColumnVarNameInTable="columnResourceID" msprop:Generator_ColumnPropNameInTable="ResourceIDColumn" type="xs:int" minOccurs="0" />
197 </xs:sequence>
198 </xs:complexType>
199 </xs:element>
200 <xs:element name="Resources" msprop:Generator_UserTableName="Resources" msprop:Generator_RowDeletedName="ResourcesRowDeleted" msprop:Generator_TableClassName="ResourcesDataTable" msprop:Generator_RowChangedName="ResourcesRowChanged" msprop:Generator_RowClassName="ResourcesRow" msprop:Generator_RowChangingName="ResourcesRowChanging" msprop:Generator_RowEvArgName="ResourcesRowChangeEvent" msprop:Generator_RowEvHandlerName="ResourcesRowChangeEventHandler" msprop:Generator_TablePropName="Resources" msprop:Generator_TableVarName="tableResources" msprop:Generator_RowDeletingName="ResourcesRowDeleting">
201 <xs:complexType>
202 <xs:sequence>
203 <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
204 <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
205 <xs:simpleType>
206 <xs:restriction base="xs:string">
207 <xs:maxLength value="255" />
208 </xs:restriction>
209 </xs:simpleType>
210 </xs:element>
211 <xs:element name="Image" msprop:Generator_UserColumnName="Image" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInTable="ImageColumn" type="xs:base64Binary" minOccurs="0" />
212 </xs:sequence>
213 </xs:complexType>
214 </xs:element>
215 <xs:element name="Appointments" msprop:Generator_UserTableName="Appointments" msprop:Generator_RowDeletedName="AppointmentsRowDeleted" msprop:Generator_TableClassName="AppointmentsDataTable" msprop:Generator_RowChangedName="AppointmentsRowChanged" msprop:Generator_RowClassName="AppointmentsRow" msprop:Generator_RowChangingName="AppointmentsRowChanging" msprop:Generator_RowEvArgName="AppointmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AppointmentsRowChangeEventHandler" msprop:Generator_TablePropName="Appointments" msprop:Generator_TableVarName="tableAppointments" msprop:Generator_RowDeletingName="AppointmentsRowDeleting">
216 <xs:complexType>
217 <xs:sequence>
218 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
219 <xs:element name="Summary" msprop:Generator_UserColumnName="Summary" msprop:Generator_ColumnPropNameInRow="Summary" msprop:Generator_ColumnVarNameInTable="columnSummary" msprop:Generator_ColumnPropNameInTable="SummaryColumn">
220 <xs:simpleType>
221 <xs:restriction base="xs:string">
222 <xs:maxLength value="255" />
223 </xs:restriction>
224 </xs:simpleType>
225 </xs:element>
226 <xs:element name="Start" msprop:Generator_UserColumnName="Start" msprop:Generator_ColumnPropNameInRow="Start" msprop:Generator_ColumnVarNameInTable="columnStart" msprop:Generator_ColumnPropNameInTable="StartColumn" type="xs:dateTime" />
227 <xs:element name="End" msprop:Generator_UserColumnName="End" msprop:Generator_ColumnPropNameInRow="End" msprop:Generator_ColumnVarNameInTable="columnEnd" msprop:Generator_ColumnPropNameInTable="EndColumn" type="xs:dateTime" />
228 <xs:element name="RecurrenceRule" msprop:Generator_UserColumnName="RecurrenceRule" msprop:Generator_ColumnPropNameInRow="RecurrenceRule" msprop:Generator_ColumnVarNameInTable="columnRecurrenceRule" msprop:Generator_ColumnPropNameInTable="RecurrenceRuleColumn" minOccurs="0">
229 <xs:simpleType>
230 <xs:restriction base="xs:string">
231 <xs:maxLength value="1024" />
232 </xs:restriction>
233 </xs:simpleType>
234 </xs:element>
235 <xs:element name="MasterEventId" msprop:Generator_UserColumnName="MasterEventId" msprop:Generator_ColumnPropNameInRow="MasterEventId" msprop:Generator_ColumnVarNameInTable="columnMasterEventId" msprop:Generator_ColumnPropNameInTable="MasterEventIdColumn" type="xs:int" minOccurs="0" />
236 <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn" minOccurs="0">
237 <xs:simpleType>
238 <xs:restriction base="xs:string">
239 <xs:maxLength value="255" />
240 </xs:restriction>
241 </xs:simpleType>
242 </xs:element>
243 <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
244 <xs:simpleType>
245 <xs:restriction base="xs:string">
246 <xs:maxLength value="1073741823" />
247 </xs:restriction>
248 </xs:simpleType>
249 </xs:element>
250 <xs:element name="BackgroundId" msprop:Generator_UserColumnName="BackgroundId" msprop:Generator_ColumnPropNameInRow="BackgroundId" msprop:Generator_ColumnVarNameInTable="columnBackgroundId" msprop:Generator_ColumnPropNameInTable="BackgroundIdColumn" type="xs:int" />
251 <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" minOccurs="0" />
252 </xs:sequence>
253 </xs:complexType>
254 </xs:element>
255 </xs:choice>
256 </xs:complexType>
257 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
258 <xs:selector xpath=".//mstns:Resources" />
259 <xs:field xpath="mstns:ID" />
260 </xs:unique>
261 <xs:unique name="Appointments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
262 <xs:selector xpath=".//mstns:Appointments" />
263 <xs:field xpath="mstns:ID" />
264 </xs:unique>
265 </xs:element>
266 <xs:annotation>
267 <xs:appinfo>
268 <msdata:Relationship name="FK_TransientAppointmentsResources_Appointments" msdata:parent="Appointments" msdata:child="TransientAppointmentsResources" msdata:parentkey="ID" msdata:childkey="AppointmentID" msprop:Generator_UserRelationName="FK_TransientAppointmentsResources_Appointments" msprop:Generator_RelationVarName="relationFK_TransientAppointmentsResources_Appointments" msprop:Generator_UserChildTable="TransientAppointmentsResources" msprop:Generator_UserParentTable="Appointments" msprop:Generator_ParentPropName="AppointmentsRow" msprop:Generator_ChildPropName="GetTransientAppointmentsResourcesRows" />
269 <msdata:Relationship name="FK_TransientAppointmentsResources_Resources" msdata:parent="Resources" msdata:child="TransientAppointmentsResources" msdata:parentkey="ID" msdata:childkey="ResourceID" msprop:Generator_UserRelationName="FK_TransientAppointmentsResources_Resources" msprop:Generator_RelationVarName="relationFK_TransientAppointmentsResources_Resources" msprop:Generator_UserChildTable="TransientAppointmentsResources" msprop:Generator_UserParentTable="Resources" msprop:Generator_ParentPropName="ResourcesRow" msprop:Generator_ChildPropName="GetTransientAppointmentsResourcesRows" />
270 </xs:appinfo>
271 </xs:annotation>
272 </xs:schema>
2 <xs:schema id="SchedulerDataset" targetNamespace="http://tempuri.org/SchedulerDataset.xsd" xmlns:mstns="http://tempuri.org/SchedulerDataset.xsd" xmlns="http://tempuri.org/SchedulerDataset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
3 <xs:annotation>
4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
6 <Connections>
7 <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="QuanLyNhanSuConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="QuanLyNhanSuConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QuanLyNhanSu.Properties.Settings.GlobalReference.Default.QuanLyNhanSuConnectionString" Provider="System.Data.SqlClient" />
8 </Connections>
9 <Tables>
10 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TransientAppointmentsResourcesTableAdapter" GeneratorDataComponentClassName="TransientAppointmentsResourcesTableAdapter" Name="TransientAppointmentsResources" UserDataComponentName="TransientAppointmentsResourcesTableAdapter">
11 <MainSource>
12 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.TransientAppointmentsResources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
13 <InsertCommand>
14 <DbCommand CommandType="Text" ModifiedByUser="false">
15 <CommandText>INSERT INTO [dbo].[TransientAppointmentsResources] ([AppointmentID], [ResourceID]) VALUES (@AppointmentID, @ResourceID)</CommandText>
16 <Parameters>
17 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AppointmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppointmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
18 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ResourceID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResourceID" SourceColumnNullMapping="false" SourceVersion="Current" />
19 </Parameters>
20 </DbCommand>
21 </InsertCommand>
22 <SelectCommand>
23 <DbCommand CommandType="Text" ModifiedByUser="false">
24 <CommandText>SELECT AppointmentID, ResourceID FROM dbo.TransientAppointmentsResources</CommandText>
25 <Parameters />
26 </DbCommand>
27 </SelectCommand>
28 </DbSource>
29 </MainSource>
30 <Mappings>
31 <Mapping SourceColumn="AppointmentID" DataSetColumn="AppointmentID" />
32 <Mapping SourceColumn="ResourceID" DataSetColumn="ResourceID" />
33 </Mappings>
34 <Sources />
35 </TableAdapter>
36 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ResourcesTableAdapter" GeneratorDataComponentClassName="ResourcesTableAdapter" Name="Resources" UserDataComponentName="ResourcesTableAdapter">
37 <MainSource>
38 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.Resources" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
39 <DeleteCommand>
40 <DbCommand CommandType="Text" ModifiedByUser="false">
41 <CommandText>DELETE FROM [dbo].[Resources] WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)))</CommandText>
42 <Parameters>
43 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
44 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
45 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
46 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
47 </Parameters>
48 </DbCommand>
49 </DeleteCommand>
50 <InsertCommand>
51 <DbCommand CommandType="Text" ModifiedByUser="false">
52 <CommandText>INSERT INTO [dbo].[Resources] ([ID], [Name], [Image]) VALUES (@ID, @Name, @Image);
53 SELECT ID, Name, Image FROM Resources WHERE (ID = @ID)</CommandText>
54 <Parameters>
55 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
56 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
57 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
58 </Parameters>
59 </DbCommand>
60 </InsertCommand>
61 <SelectCommand>
62 <DbCommand CommandType="Text" ModifiedByUser="false">
63 <CommandText>SELECT ID, Name, Image FROM dbo.Resources</CommandText>
64 <Parameters />
65 </DbCommand>
66 </SelectCommand>
67 <UpdateCommand>
68 <DbCommand CommandType="Text" ModifiedByUser="false">
69 <CommandText>UPDATE [dbo].[Resources] SET [ID] = @ID, [Name] = @Name, [Image] = @Image WHERE (([ID] = @Original_ID) AND ([Name] = @Original_Name) AND ((@IsNull_Image = 1 AND [Image] IS NULL) OR ([Image] = @Original_Image)));
70 SELECT ID, Name, Image FROM Resources WHERE (ID = @ID)</CommandText>
71 <Parameters>
72 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
73 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
74 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Current" />
75 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
76 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
77 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Image" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="true" SourceVersion="Original" />
78 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Original_Image" Precision="0" ProviderType="Binary" Scale="0" Size="0" SourceColumn="Image" SourceColumnNullMapping="false" SourceVersion="Original" />
79 </Parameters>
80 </DbCommand>
81 </UpdateCommand>
82 </DbSource>
83 </MainSource>
84 <Mappings>
85 <Mapping SourceColumn="ID" DataSetColumn="ID" />
86 <Mapping SourceColumn="Name" DataSetColumn="Name" />
87 <Mapping SourceColumn="Image" DataSetColumn="Image" />
88 </Mappings>
89 <Sources />
90 </TableAdapter>
91 <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AppointmentsTableAdapter" GeneratorDataComponentClassName="AppointmentsTableAdapter" Name="Appointments" UserDataComponentName="AppointmentsTableAdapter">
92 <MainSource>
93 <DbSource ConnectionRef="QuanLyNhanSuConnectionString (Settings)" DbObjectName="QuanLyNhanSu.dbo.Appointments" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
94 <DeleteCommand>
95 <DbCommand CommandType="Text" ModifiedByUser="false">
96 <CommandText>DELETE FROM [dbo].[Appointments] WHERE (([ID] = @Original_ID) AND ([Summary] = @Original_Summary) AND ([Start] = @Original_Start) AND ([End] = @Original_End) AND ((@IsNull_RecurrenceRule = 1 AND [RecurrenceRule] IS NULL) OR ([RecurrenceRule] = @Original_RecurrenceRule)) AND ((@IsNull_MasterEventId = 1 AND [MasterEventId] IS NULL) OR ([MasterEventId] = @Original_MasterEventId)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)) AND ([BackgroundId] = @Original_BackgroundId) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)))</CommandText>
97 <Parameters>
98 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
99 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Original" />
100 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
101 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
102 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecurrenceRule" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="true" SourceVersion="Original" />
103 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Original" />
104 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="true" SourceVersion="Original" />
105 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Original" />
106 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
107 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
108 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Original" />
109 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
110 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
111 </Parameters>
112 </DbCommand>
113 </DeleteCommand>
114 <InsertCommand>
115 <DbCommand CommandType="Text" ModifiedByUser="false">
116 <CommandText>INSERT INTO [dbo].[Appointments] ([Summary], [Start], [End], [RecurrenceRule], [MasterEventId], [Location], [Description], [BackgroundId], [StatusID]) VALUES (@Summary, @Start, @End, @RecurrenceRule, @MasterEventId, @Location, @Description, @BackgroundId, @StatusID);
117 SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM Appointments WHERE (ID = SCOPE_IDENTITY())</CommandText>
118 <Parameters>
119 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
120 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
121 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
122 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Current" />
123 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Current" />
124 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
125 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
126 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Current" />
127 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
128 </Parameters>
129 </DbCommand>
130 </InsertCommand>
131 <SelectCommand>
132 <DbCommand CommandType="Text" ModifiedByUser="false">
133 <CommandText>SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM dbo.Appointments</CommandText>
134 <Parameters />
135 </DbCommand>
136 </SelectCommand>
137 <UpdateCommand>
138 <DbCommand CommandType="Text" ModifiedByUser="false">
139 <CommandText>UPDATE [dbo].[Appointments] SET [Summary] = @Summary, [Start] = @Start, [End] = @End, [RecurrenceRule] = @RecurrenceRule, [MasterEventId] = @MasterEventId, [Location] = @Location, [Description] = @Description, [BackgroundId] = @BackgroundId, [StatusID] = @StatusID WHERE (([ID] = @Original_ID) AND ([Summary] = @Original_Summary) AND ([Start] = @Original_Start) AND ([End] = @Original_End) AND ((@IsNull_RecurrenceRule = 1 AND [RecurrenceRule] IS NULL) OR ([RecurrenceRule] = @Original_RecurrenceRule)) AND ((@IsNull_MasterEventId = 1 AND [MasterEventId] IS NULL) OR ([MasterEventId] = @Original_MasterEventId)) AND ((@IsNull_Location = 1 AND [Location] IS NULL) OR ([Location] = @Original_Location)) AND ([BackgroundId] = @Original_BackgroundId) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)));
140 SELECT ID, Summary, Start, [End], RecurrenceRule, MasterEventId, Location, Description, BackgroundId, StatusID FROM Appointments WHERE (ID = @ID)</CommandText>
141 <Parameters>
142 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Current" />
143 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Current" />
144 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Current" />
145 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Current" />
146 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Current" />
147 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
148 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
149 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Current" />
150 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
151 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
152 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Summary" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Summary" SourceColumnNullMapping="false" SourceVersion="Original" />
153 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Start" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Start" SourceColumnNullMapping="false" SourceVersion="Original" />
154 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_End" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="End" SourceColumnNullMapping="false" SourceVersion="Original" />
155 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RecurrenceRule" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="true" SourceVersion="Original" />
156 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RecurrenceRule" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RecurrenceRule" SourceColumnNullMapping="false" SourceVersion="Original" />
157 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="true" SourceVersion="Original" />
158 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MasterEventId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MasterEventId" SourceColumnNullMapping="false" SourceVersion="Original" />
159 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Location" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="true" SourceVersion="Original" />
160 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Original" />
161 <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BackgroundId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BackgroundId" SourceColumnNullMapping="false" SourceVersion="Original" />
162 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
163 <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
164 <Parameter AllowDbNull="false" AutogeneratedName="ID" ColumnName="ID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
165 </Parameters>
166 </DbCommand>
167 </UpdateCommand>
168 </DbSource>
169 </MainSource>
170 <Mappings>
171 <Mapping SourceColumn="ID" DataSetColumn="ID" />
172 <Mapping SourceColumn="Summary" DataSetColumn="Summary" />
173 <Mapping SourceColumn="Start" DataSetColumn="Start" />
174 <Mapping SourceColumn="End" DataSetColumn="End" />
175 <Mapping SourceColumn="RecurrenceRule" DataSetColumn="RecurrenceRule" />
176 <Mapping SourceColumn="MasterEventId" DataSetColumn="MasterEventId" />
177 <Mapping SourceColumn="Location" DataSetColumn="Location" />
178 <Mapping SourceColumn="Description" DataSetColumn="Description" />
179 <Mapping SourceColumn="BackgroundId" DataSetColumn="BackgroundId" />
180 <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
181 </Mappings>
182 <Sources />
183 </TableAdapter>
184 </Tables>
185 <Sources />
186 </DataSource>
187 </xs:appinfo>
188 </xs:annotation>
189 <xs:element name="SchedulerDataset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="SchedulerDataset" msprop:Generator_UserDSName="SchedulerDataset" msprop:EnableTableAdapterManager="true">
190 <xs:complexType>
191 <xs:choice minOccurs="0" maxOccurs="unbounded">
192 <xs:element name="TransientAppointmentsResources" msprop:Generator_UserTableName="TransientAppointmentsResources" msprop:Generator_RowDeletedName="TransientAppointmentsResourcesRowDeleted" msprop:Generator_TableClassName="TransientAppointmentsResourcesDataTable" msprop:Generator_RowChangedName="TransientAppointmentsResourcesRowChanged" msprop:Generator_RowClassName="TransientAppointmentsResourcesRow" msprop:Generator_RowChangingName="TransientAppointmentsResourcesRowChanging" msprop:Generator_RowEvArgName="TransientAppointmentsResourcesRowChangeEvent" msprop:Generator_RowEvHandlerName="TransientAppointmentsResourcesRowChangeEventHandler" msprop:Generator_TablePropName="TransientAppointmentsResources" msprop:Generator_TableVarName="tableTransientAppointmentsResources" msprop:Generator_RowDeletingName="TransientAppointmentsResourcesRowDeleting">
193 <xs:complexType>
194 <xs:sequence>
195 <xs:element name="AppointmentID" msprop:Generator_UserColumnName="AppointmentID" msprop:Generator_ColumnPropNameInRow="AppointmentID" msprop:Generator_ColumnVarNameInTable="columnAppointmentID" msprop:Generator_ColumnPropNameInTable="AppointmentIDColumn" type="xs:int" minOccurs="0" />
196 <xs:element name="ResourceID" msprop:Generator_UserColumnName="ResourceID" msprop:Generator_ColumnPropNameInRow="ResourceID" msprop:Generator_ColumnVarNameInTable="columnResourceID" msprop:Generator_ColumnPropNameInTable="ResourceIDColumn" type="xs:int" minOccurs="0" />
197 </xs:sequence>
198 </xs:complexType>
199 </xs:element>
200 <xs:element name="Resources" msprop:Generator_UserTableName="Resources" msprop:Generator_RowDeletedName="ResourcesRowDeleted" msprop:Generator_TableClassName="ResourcesDataTable" msprop:Generator_RowChangedName="ResourcesRowChanged" msprop:Generator_RowClassName="ResourcesRow" msprop:Generator_RowChangingName="ResourcesRowChanging" msprop:Generator_RowEvArgName="ResourcesRowChangeEvent" msprop:Generator_RowEvHandlerName="ResourcesRowChangeEventHandler" msprop:Generator_TablePropName="Resources" msprop:Generator_TableVarName="tableResources" msprop:Generator_RowDeletingName="ResourcesRowDeleting">
201 <xs:complexType>
202 <xs:sequence>
203 <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
204 <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn">
205 <xs:simpleType>
206 <xs:restriction base="xs:string">
207 <xs:maxLength value="255" />
208 </xs:restriction>
209 </xs:simpleType>
210 </xs:element>
211 <xs:element name="Image" msprop:Generator_UserColumnName="Image" msprop:Generator_ColumnPropNameInRow="Image" msprop:Generator_ColumnVarNameInTable="columnImage" msprop:Generator_ColumnPropNameInTable="ImageColumn" type="xs:base64Binary" minOccurs="0" />
212 </xs:sequence>
213 </xs:complexType>
214 </xs:element>
215 <xs:element name="Appointments" msprop:Generator_UserTableName="Appointments" msprop:Generator_RowDeletedName="AppointmentsRowDeleted" msprop:Generator_TableClassName="AppointmentsDataTable" msprop:Generator_RowChangedName="AppointmentsRowChanged" msprop:Generator_RowClassName="AppointmentsRow" msprop:Generator_RowChangingName="AppointmentsRowChanging" msprop:Generator_RowEvArgName="AppointmentsRowChangeEvent" msprop:Generator_RowEvHandlerName="AppointmentsRowChangeEventHandler" msprop:Generator_TablePropName="Appointments" msprop:Generator_TableVarName="tableAppointments" msprop:Generator_RowDeletingName="AppointmentsRowDeleting">
216 <xs:complexType>
217 <xs:sequence>
218 <xs:element name="ID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
219 <xs:element name="Summary" msprop:Generator_UserColumnName="Summary" msprop:Generator_ColumnPropNameInRow="Summary" msprop:Generator_ColumnVarNameInTable="columnSummary" msprop:Generator_ColumnPropNameInTable="SummaryColumn">
220 <xs:simpleType>
221 <xs:restriction base="xs:string">
222 <xs:maxLength value="255" />
223 </xs:restriction>
224 </xs:simpleType>
225 </xs:element>
226 <xs:element name="Start" msprop:Generator_UserColumnName="Start" msprop:Generator_ColumnPropNameInRow="Start" msprop:Generator_ColumnVarNameInTable="columnStart" msprop:Generator_ColumnPropNameInTable="StartColumn" type="xs:dateTime" />
227 <xs:element name="End" msprop:Generator_UserColumnName="End" msprop:Generator_ColumnPropNameInRow="End" msprop:Generator_ColumnVarNameInTable="columnEnd" msprop:Generator_ColumnPropNameInTable="EndColumn" type="xs:dateTime" />
228 <xs:element name="RecurrenceRule" msprop:Generator_UserColumnName="RecurrenceRule" msprop:Generator_ColumnPropNameInRow="RecurrenceRule" msprop:Generator_ColumnVarNameInTable="columnRecurrenceRule" msprop:Generator_ColumnPropNameInTable="RecurrenceRuleColumn" minOccurs="0">
229 <xs:simpleType>
230 <xs:restriction base="xs:string">
231 <xs:maxLength value="1024" />
232 </xs:restriction>
233 </xs:simpleType>
234 </xs:element>
235 <xs:element name="MasterEventId" msprop:Generator_UserColumnName="MasterEventId" msprop:Generator_ColumnPropNameInRow="MasterEventId" msprop:Generator_ColumnVarNameInTable="columnMasterEventId" msprop:Generator_ColumnPropNameInTable="MasterEventIdColumn" type="xs:int" minOccurs="0" />
236 <xs:element name="Location" msprop:Generator_UserColumnName="Location" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInTable="LocationColumn" minOccurs="0">
237 <xs:simpleType>
238 <xs:restriction base="xs:string">
239 <xs:maxLength value="255" />
240 </xs:restriction>
241 </xs:simpleType>
242 </xs:element>
243 <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
244 <xs:simpleType>
245 <xs:restriction base="xs:string">
246 <xs:maxLength value="1073741823" />
247 </xs:restriction>
248 </xs:simpleType>
249 </xs:element>
250 <xs:element name="BackgroundId" msprop:Generator_UserColumnName="BackgroundId" msprop:Generator_ColumnPropNameInRow="BackgroundId" msprop:Generator_ColumnVarNameInTable="columnBackgroundId" msprop:Generator_ColumnPropNameInTable="BackgroundIdColumn" type="xs:int" />
251 <xs:element name="StatusID" msprop:Generator_UserColumnName="StatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" type="xs:int" minOccurs="0" />
252 </xs:sequence>
253 </xs:complexType>
254 </xs:element>
255 </xs:choice>
256 </xs:complexType>
257 <xs:unique name="Constraint1" msdata:PrimaryKey="true">
258 <xs:selector xpath=".//mstns:Resources" />
259 <xs:field xpath="mstns:ID" />
260 </xs:unique>
261 <xs:unique name="Appointments_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
262 <xs:selector xpath=".//mstns:Appointments" />
263 <xs:field xpath="mstns:ID" />
264 </xs:unique>
265 </xs:element>
266 <xs:annotation>
267 <xs:appinfo>
268 <msdata:Relationship name="FK_TransientAppointmentsResources_Appointments" msdata:parent="Appointments" msdata:child="TransientAppointmentsResources" msdata:parentkey="ID" msdata:childkey="AppointmentID" msprop:Generator_UserRelationName="FK_TransientAppointmentsResources_Appointments" msprop:Generator_RelationVarName="relationFK_TransientAppointmentsResources_Appointments" msprop:Generator_UserChildTable="TransientAppointmentsResources" msprop:Generator_UserParentTable="Appointments" msprop:Generator_ParentPropName="AppointmentsRow" msprop:Generator_ChildPropName="GetTransientAppointmentsResourcesRows" />
269 <msdata:Relationship name="FK_TransientAppointmentsResources_Resources" msdata:parent="Resources" msdata:child="TransientAppointmentsResources" msdata:parentkey="ID" msdata:childkey="ResourceID" msprop:Generator_UserRelationName="FK_TransientAppointmentsResources_Resources" msprop:Generator_RelationVarName="relationFK_TransientAppointmentsResources_Resources" msprop:Generator_UserChildTable="TransientAppointmentsResources" msprop:Generator_UserParentTable="Resources" msprop:Generator_ParentPropName="ResourcesRow" msprop:Generator_ChildPropName="GetTransientAppointmentsResourcesRows" />
270 </xs:appinfo>
271 </xs:annotation>
272 </xs:schema>